Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “pursuits” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

69 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
pursuits104504(None) 
pursuit948271pursuit_
pursuers10376522pursuers
pursues94111372pursu_es
pursuing1146232pursuing
sunsuits845962sunsuits
bruits85714453_br_uits
bursitis1045033burs_itis
bursts85116243burs__ts
catsuits1045433catsuits
circuits1246023circuits
fruits94512493_fr_uits
hursts97213093hurs__ts
jesuits1436323_jesuits
jumpsuits2051243jumpsuits
lawsuits1142753lawsuits
missuits1078023missuits
muskits13278553mu_skits
nonsuits869153nonsuits
outsits73215253outs_its
pantsuits1144083pantsuits
parfaits1346913parfaits
parquets1936413parquets
parsnips1245533parsnips
permits11314003per_mits
persalts1038193persalts
persist9315853pers_ist
persists1049183persists
playsuits1442653playsuits
posits85718713p_os_its
probits112712573p_robits
profits122911243p_rofits
pulpits1137243pu_lpits
pundits10379293pu_ndits
purifies13311923purifies
purins83722653pur__ins
puris75332023pur__i_s
purist85525053pur__ist
purists94014073pur_ists
purities10316283purities
purity114114913pur__ity
purlins93415423pur_lins
purloins1077033purloins
purports1265783purports
purpuras12105073purpuras
purpures1276143purpures
purpurins1364463purpurins
pursers93916093purs_ers
purses84826373purs__es
pursier94012753purs_ier
pursiest102812123purs_iest
pursily1238213purs_ily
pursing103715553purs_ing
pursuant1046563pursuant
pursue84512253pursu__e
pursued10388133pursu_ed
pursuer9338893pursu_er
pursuivants165923pursuivants
pussies93615693pu_ssies
pusslies1036173pusslies
putouts937083putou_ts
suits55028053___suits
sunsuit748693sunsuit_
surfeits1146223surfeits
turbits969233tur_bits
turnspits1142573turnspits
ursids737823_urs_ids
wetsuits1143233wetsuits
wursts95211163wurs__ts

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.1531167915.0
2DLD Change Limit146162697.90618487.5
3Display Results69690.0501380.0
 (SQL Overall)178691698.10922036.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.