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

58 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
pearlized214556(None) 
pearled10411552pearl__ed
pearlier1037322pearli_er
pearlite1039442pearlite_
pearlites1138232pearlites
penalized211210242penalized
realized182514222rea_lized
bearlike14156793bearlike_
deadlined12125323deadlined
dualized1937403dua_lized
earlier72612743_earli_er
headlined14135133headlined
hebraized2443953hebraized
heroized21298463he_roized
idealized2046653idea_lized
legalized2047523legalized
metalized21412183metalized
metallized2265583metallized
moralized21310753moralized
nearlier836803nearli_er
nebulized2154073nebulized
panelized2147033panelized
paralyzed2445293p_aralyzed
parlayed1435823p_arlayed
parled94626293p_arl__ed
parleyed1436243p_arleyed
parried103615723p_arri_ed
parslied1137823p_arsli_ed
partied103516553p_arti_ed
peaklike13115373peaklike_
pealed95322813pea_l__ed
pealike131211273pea_like_
pearler9310373pearl__er
pearliest1139363pearliest
pearling11912013pearli_ng
pearlitic1345523pearlitic
pectized22257593pe_ctized
penalised12108833penalised
penalize19912753penalize_
penalizes20911853penalizes
peptized22237523pe_ptized
periled10316323pe_r_iled
perilled11410113pe_rilled
perlite9317323pe_rlite_
perlites10316363pe_rlites
pluralized2244613pluralized
polarized21610283polar_ized
prized184415393p__r_ized
pyrolized2446123pyrolized
realised92214533rea_lised
realize162717083rea_lize_
realizer172412113rea_lizer
realizes173116843rea_lizes
ruralized1947903ruralized
spearlike1544143spearlike_
velarized2256803velar_ized
wearied112911813wear_i_ed
yearlies1137603yearli_es

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.420425454.8
2DLD Change Limit148641587.12620859.0
3Display Results58580.0134461.5
 (SQL Overall)178691587.55923639.5
 
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.