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

46 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
recruiters124371(None) 
recruiter1144871recruiter_
reciters102613112rec__iters
recounters1246212recounters
recruited1236452recruite_d
recruits1036562recruit__s
requiters18176552re_quiters
rewriters1236342rewr_iters
bruiters10329143__bruiters
cruisers10438273__cruisers
decaliters1345213decaliters
deciliters1345173deciliters
decriers11299733decr_i_ers
fruiters11328183__fruiters
rebutters1195093re_butters
recamiers1345513recami_ers
recanters112310483rec_anters
receivers1436363rec_eivers
recharters1555423recharters
reciter94117263rec__iter_
recites93524583rec__ite_s
reclaimers1443593reclaimers
recliners11279113rec_liners
recoilers11318153rec_oilers
recounter1137943recounter_
recrates102420373recr_ate_s
recreates11313363recreate_s
recruit939773recruit___
recruiting1347903recruiting
recruitment15113783recruitment
recruitments16113393recruitments
redbaiters1343603redbaiters
refrainers1344473refrainers
refuters11449613re_fu_ters
regretters1144093regretters
rencounters1343303rencounters
reprinters1295793reprinters
requirers18165003re_quirers
requiter17168643re_quiter_
requites171511763re_quite_s
retreaters1047543retreaters
reuniters936423re_uniters
reutters8138573re__utters
rewriter1137923rewr_iter_
rewrites11311063rewr_ite_s
verditers1344993ve_rditers

Search took 7 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.423422437.4
2DLD Change Limit140603465.93623686.5
3Display Results46460.0162875.0
 (SQL Overall)178691466.37528030.0
 
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.