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 “displayers” 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.

47 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
displayers165482(None) 
displacers1545011displacers
displayer1545831displayer_
displacer1446432displacer_
displaces1448592displace_s
displayed1645882displaye_d
displays1446292display__s
mislayers1445942mis_layers
bilayers13296923bi__layers
delayers12268663d__elayers
deployers1545063d_eployers
desolaters1146043desolaters
dilaters92513063di__laters
diplexers1943573di_plexers
disclaimers1653133disclaimers
disclosers1375193disclosers
disgracers1444733disgracers
dishwaters1744023dishwaters
dislikers14286423dis_likers
disobeyers1642383disobeyers
disparagers1553393disparagers
dispellers13115453dispellers
dispensers13146743dispensers
dispersers13137423dispersers
displace1348653displace__
displaced1546793displace_d
displants1248073displa_nts
display1336663display___
displaying1746313displaying
displeases1345683displease_s
displodes1347863displode_s
displumes1444983displume_s
disposers1238373disp_osers
dispraisers1443423dispraisers
disprovers16145283disprovers
disputers1236613disp_uters
dissuaders1273833dissuaders
inlayers1135643_i_nlayers
minelayers1543453minelayers
mislayer1337503mis_layer_
misplaces1537953misplace_s
misplayed1745303misplaye_d
misplays1555543misplay__s
nonplayers1543943nonplayers
players124313763___players
slayers104513323__s_layers
sprayers13367053__sprayers

Search took 6 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 Filter1786911406030.420425454.8
2DLD Change Limit140603475.36026231.9
3Display Results47470.0162937.5
 (SQL Overall)178691475.79630830.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.