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

59 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
roturiers94455(None) 
roturier836031roturier_
couriers103213172co_uriers
couturiers1243852couturiers
returners9376552returners
rotaries8315692rotarie_s
bouviers1375003bo_uviers
buriers94017193__buriers
catbriers1344143catbriers
costumiers1442973costumiers
coteries10422703coterie_s
cottiers10399153cot_tiers
courier93617893co_urier_
coursers104412303co_ursers
courters103015373co_urters
courtiers1146693co_urtiers
couturier1145423couturier_
couturiere1252423couturiere
couturieres1352043couturieres
croupiers1334653cro_upiers
hoteliers1245803hoteliers
maturers1037383matur_ers
mourners1036913mo_urners
notaries8314933notarie_s
notifiers1245023notifiers
outliers82610673_outliers
outriders10237223_outriders
posturers1137053postur_ers
pourers93513673po_ur_ers
procurers1345033procur_ers
ratifiers1236453ratifiers
reburies10311143reburie_s
requirers18165003requirers
retarders10227573retarders
retirers84311533retir_ers
retorters938773retorters
retries74129073ret_rie_s
returnees9396113returnees
returner8397983returner_
roarers73812743ro_ar_ers
rogueries1047003roguerie_s
roperies10315763roperie_s
rosaries8312783rosarie_s
roseries8317313roserie_s
rotifers1136043rot_ifers
rotters74421393rot__ters
roughers12329183ro_ughers
rounders92613693ro_unders
roupier9319493ro_upier_
rousers75220143ro_u_sers
rousters84315683ro_usters
routers74822873ro_u_ters
studiers9236623_studiers
torturers944343tortur_ers
tourers73512743to_ur_ers
triers64321523__t_riers
turners73912893__turners
votaries11312013votarie_s
worriers11257813wo_rriers

Search took 8 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 Filter1786911486410.406440125.6
2DLD Change Limit148641596.89021573.4
3Display Results59590.0331787.9
 (SQL Overall)178691597.32924381.4
 
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.